Tabela DiagnosisListItem

Definicja tabeli DiagnosisListItem

Name

DiagnosisListItem

Code

DiagnosisListItem

Comment

Pozycja pacjenta na liscie chorób przewleklych


Lista kolumn tabeli DiagnosisListItem

Name

Code

DiagnosisListItemID

DiagnosisListItemID

ICDID

ICDID

PatientID

PatientID

StartDT

StartDT

StopDT

StopDT


Kolumna DiagnosisListItemID tabeli DiagnosisListItem

Definicja kolumny DiagnosisListItemID tabeli DiagnosisListItem

Name

DiagnosisListItemID

Code

DiagnosisListItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ICDID tabeli DiagnosisListItem

Definicja kolumny ICDID tabeli DiagnosisListItem

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli DiagnosisListItem

Definicja kolumny PatientID tabeli DiagnosisListItem

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli DiagnosisListItem

Definicja kolumny StartDT tabeli DiagnosisListItem

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

data wpisania na liste


Kolumna StopDT tabeli DiagnosisListItem

Definicja kolumny StopDT tabeli DiagnosisListItem

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

data zdjecia z listy


Lista kluczy tabeli DiagnosisListItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DiagnosisListItem

Definicja klucza Identifier_1 tabeli DiagnosisListItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment